FO_IF_Translations
This table is used to specify translation values for external data arriving through the Client Data Concentrator interfaces (CDC). [Being expanded to also include TDC]
Each record represents a particular field type of foreign and native values for an MPI qualifier and an Interface code. An interface code is assigned in the config file of the comms and processor jobs of an interface.
The combination of MPI Qualifier, Interface Code and Translation Type determines which definition is right to translate.
Field | Type | Notes | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FO_IF_Translations_ID |
int |
ID field, a counter. Unique |
||||||||||||
InterfaceCode |
varchar(50) |
Interface code for this translation. The interface code is defined in the Comms and Processor jobs config files. |
||||||||||||
TranslationType |
varchar(50) |
Enter a single character that represents a translation type. Allowed values:
|
||||||||||||
ForeignValue |
varchar(50) |
Enter a value for this translation type in the external system. |
||||||||||||
FPValue |
varchar(50) |
Enter a value to translate to in FAST. For type I insurance translations, if the FPValue is "*DNU*", then the system will not record any insurances from that message. The system will still record a value for Bill To, it will not be left blank. This is only honored for the primary insurance (first IN1) segment in a message. |
||||||||||||
MPIQualifier |
varchar(50) |
MPI qualifier code. Enter a valid MPI qualifier code. |
||||||||||||
CreateDate |
datetime |
Date record was created. Informational |
||||||||||||
CreatedBy |
varchar(50) |
User who created the record. Informational |
||||||||||||
EditDate |
datetime |
Date record was edited. Informational |
||||||||||||
EditedBy |
varchar(50) |
User who last edited the record. Informational |
||||||||||||
ForceBillTo |
varchar(50) |
Defines the billto value for every order created by reference to this translation. Enter a valid FAST billto value. See Bill To table for valid entries of long code. [Insert link target_blank to Bill To table in the doc] Only applies to translation type I insurance for the first IN1 segment. This will override what was sent in the message or a default value for this MPI qualifier. This logic will be used only if the translation rules are activated to cause the system to translate the insurance code in the message. An IN1 segment must have at least an insurance code and a policy number to qualify as a valid segment. If it does not, no translation will be applied. |
||||||||||||
ClientCode |
varchar(50) |
Client code. Enter a valid client code. >>>> NEED More Definition <<<< |